using System;
using System.Data;
using System.Collections.Generic;
using System.ServiceModel;
using eTMS.DAO;
namespace eTMS.Services
{
    /********************************BEGIN ISinhVienService****************************************/
    ///<summary>
    /// <para>Author: Auto generated class by CSharp Code Generator v2.0</para>
    /// <para>Date:09/08/2010 12:01:35</para>
    /// <para>Class Name: ISinhVienService</para>
    /// <para>Description: </para>
    ///</summary>


    public partial interface ISinhVienService
    {
        [OperationContract]
        DataSet SearchSinhVien(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity);

        [OperationContract]
        DataSet SearchSinhVienChuaPhanLop(int NganhHoc_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity);

        [OperationContract]
        bool DeleteSinhVienByListSinhVien_ID(List<int> lsSinhVien_ID);

        [OperationContract]
        DataSet SearchSinhVienWithDiemMonHoc(bool AllowLeftJoinSinhVienMonHoc, bool IsJoinToDiemMonHoc, bool IsJoinToDangKyHocPhan, bool IsJoinToSinhVienLopTinChi, int MonHoc_ID, int LoaiDiem_ID, int LanThi, int HocKy_ID, int NamHoc_ID, int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity, string Filter);
        [OperationContract]
        DataSet SearchDataCommonUpdate(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, string TableUpdate, List<string> LsColumnUpdate, string ColumnLink, string Column_ID, bool IsInnerJoin, SinhVienEntity sinhVienEntity, string Filter);

        [OperationContract]
        DataSet SelectDataLookUpTable(string TableLookUp, string ValueMember, string DisplayMember);

        [OperationContract]
        bool UpdateDataCommon(string TableUpdate, string Column_ID, string ColumnUpdate, object Value, object ID);

        [OperationContract]
        DataSet SearchSinhVienNopTien(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity, int NamHoc_ID, int HocKy_ID, DateTime TuNgay, DateTime DenNgay, bool IsFindByNgay, byte KieuThanhToan);

        [OperationContract]
        DataSet TongHopDoiTuongTroCap(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity, int NamHoc_ID, int HocKy_ID);

        [OperationContract]
        DataSet SearchDanhSachHocBong(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity, int NamHoc_ID, int HocKy_ID);

        [OperationContract]
        DataSet SearchSinhVienUsers(List<int> lsSinhVien_ID);

        [OperationContract]
        DataSet SearchSinhVienLopHocPhan(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, List<int> lsLopHocPhan_ID, SinhVienEntity sinhVienEntity);

        [OperationContract]
        DataSet SearchSinhVienWithDiemTongKetHocKy(int HocKy_ID, int NamHoc_ID, int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity);

        [OperationContract]
        DataSet SearchSinhVienHocLai(int NamHoc_ID, int HocKy_ID, int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity);
        [OperationContract]
        DataSet SelectAllDSDataBySQL(string SQL, Dictionary<string, object> Parameters);

        [OperationContract]
        DataSet SearchSinhVien_ID(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity);
        [OperationContract]
        DataSet SearchSinhVienHocMonHoc(int MonHoc_ID, int NamHoc_ID, int HocKy_ID, int Lop_ID, SinhVienEntity sinhVienEntity);
        [OperationContract]
        DataSet ThongKeSinhVien(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity, string TableJoin, string DisplayColName, string JoinKey, bool IsInnerJoin);
        [OperationContract]
        DataSet SelectAllDSSinhVienByListID(List<int> LsSinhVien_Id);

    }
    /*****************************************************************************************************/
    /**********************************END SinhVienWebService*****************************************/
    /*****************************************************************************************************/
}

